﻿CREATE TABLE [dbo].[DicCategory] (
    [ID]              INT              IDENTITY (1, 1) NOT NULL,
    [PID]             INT              NULL,
    [CateID]          UNIQUEIDENTIFIER NOT NULL,
    [PCateID]         UNIQUEIDENTIFIER NULL,
    [CateName]        NVARCHAR (50)    NOT NULL,
    [AnotherName]     NVARCHAR (50)    NULL,
    [MetaKeyword]     NVARCHAR (100)   NULL,
    [MetaDescription] NVARCHAR (200)   NULL,
    [Sort]            INT              NULL,
    [PCImageID]       UNIQUEIDENTIFIER NULL,
    [MobileImageID]   UNIQUEIDENTIFIER NULL,
    [MobileImageID2]  UNIQUEIDENTIFIER NULL,
    [ImageID]         UNIQUEIDENTIFIER NULL,
    [ShowStatus]      TINYINT          NULL,
    [DelStatus]       TINYINT          NULL,
    [ManagerID]       INT              NULL,
    [UpdateDate]      DATETIME         NULL,
    [AddDate]         DATETIME         NOT NULL,
    [CateType]        TINYINT          NOT NULL,
    [Path]            VARCHAR (MAX)    NULL,
    [IsEnd]           TINYINT          NULL,
    [TenantID]        UNIQUEIDENTIFIER NULL,
    [VideoID]         UNIQUEIDENTIFIER NULL,
    CONSTRAINT [PK_DicCategory] PRIMARY KEY CLUSTERED ([CateID] ASC)
);






GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'分类表', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'分类标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'CateID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'父标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'PCateID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'分类名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'CateName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'分类别名', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'AnotherName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'关键词', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'MetaKeyword';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'描述', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'MetaDescription';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'排序', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'Sort';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'PC图片标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'PCImageID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'移动图片标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'MobileImageID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'移动分类宣传图片。Images表 ImageID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'MobileImageID2';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'图片标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'ImageID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'显示状态.0：不显示；1：显示；', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'ShowStatus';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'删除状态.Null：使用中；1:已删除；2：回收站；3：待销毁', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'DelStatus';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'管理员标识.后台管理员。 NetManagerInfo表', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'ManagerID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'修改时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'UpdateDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'添加时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'AddDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'分类类型。10:商品分类；20：专题分类；30：文章分类；40：模板分类', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'CateType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否末级分类。1：是', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicCategory', @level2type = N'COLUMN', @level2name = N'IsEnd';

